Annuity questions

Q 1-Future value of annuity problem

You deposit $10,000 into a retirement account at the end of the next 10 years earning 9% interest, what is the future value of your retirement after 10 years?

Q 2-Perpetuity problem

What is the value of a perpetuity with an annual payment of $100 and a discount rate of 6%?

Q 3-Present value of single sum problem

You are going to be given $100,000 in 12 years. Assuming an interest rate of 3.5%, what is the present value of this amount?

Q-4 Future value of annuity problem

You deposit $5,000 into a retirement account at the end of the next 15 years earning 8% interest, what is the future value of your retirement after 15 years?

Q-5 Present value of annuity problem

You will receive $1,000 at the end of the next 10 years, assuming a 7% discount rate, what is the present value of the cash flows?

Please show your work. It can be completed in an excel spreadsheet.

Annuity questions

Q 1-Future value of annuity problem

You deposit $10,000 into a retirement account at the end of the next 10 years earning 9% interest, what is the future value of your retirement after 10 years?

Q 2-Perpetuity problem

What is the value of a perpetuity with an annual payment of $100 and a discount rate of 6%?

Q 3-Present value of single sum problem

You are going to be given $100,000 in 12 years. Assuming an interest rate of 3.5%, what is the present value of this amount?

Q-4 Future value of annuity problem

You deposit $5,000 into a retirement account at the end of the next 15 years earning 8% interest, what is the future value of your retirement after 15 years?

Q-5 Present value of annuity problem

You will receive $1,000 at the end of the next 10 years, assuming a 7% discount rate, what is the present value of the cash flows?

Please show your work. It can be completed in an excel spreadsheet.